
/****** Object:  Stored Procedure [sapro].GiaoDichGet    Script Date: Thursday, March 18, 2010 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spGiaoDichGet]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [sapro].[spGiaoDichGet]
GO

	
			
	
/******************************************************************************
**		File: 
**		Name: [sapro].spGiaoDichGet
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 3/18/2010 5:04:09 PM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE [sapro].spGiaoDichGet
	@Mobile nvarchar(20),
	@NgayGD datetime,
	@GioGD datetime
AS

SELECT
	[Mobile],
	[NgayGD],
	[GioGD],
	[SoDiemTruoc],
	[SoDiemGD],
	[SoDiemSau],
	[NoiDung]
FROM
	[sapro].[GiaoDich]
WHERE
	[Mobile] = @Mobile
	AND [NgayGD] = @NgayGD
	AND [GioGD] = @GioGD

GO
	

	

